Your Browser does not have javascript enabled. Your viewing of this site will be greatly limited. Please utilize a javascript-enabled browser to optimally view our website. Thank you.

HELP

Intermediate PHP and MySQL

Richard Blum

Final Exam

Completion >

Important: Please note that we do not use your quiz scores to determine your eligibility for a completion letter or to measure your success in meeting the objectives of this course. Our assessment of your performance in this course will rely exclusively on your final exam score. In order to obtain the highest possible score on the final exam, we strongly recommend that you make sure you have taken and passed every quiz. We also recommend that you print and review a copy of the final exam before you actually take the exam.

Please review your selections before submitting. You may only submit your final exam answers once. In order to qualify for the Completion Letter, you'll need to successfully complete the final exam with a score of 65% or higher. Within 1-2 minutes, you will receive an evaluation of your answers.

How are PHP extensions defined in the PHP preprocessor?
Using the extension= statement in the php.ini file.

Using the module= statement in the httpd.conf file.

Using the module= statement in the PHP preprocessor.

Using the extension= statement in the httpd.conf file.
What does the mysql_connect() PHP function do?
Connect the PHP program to a MySQL table.

Connect the PHP program to a specified MySQL database.

Connect to a specified server using a specified user ID and password.

Send an SQL statement to a specified MySQL database.
What PHP feature allows you to save shopping cart items for individual visitors in a temporary location that keeps the information for the duration of the Web site visit?
Session cookies.

HTML forms.

PHP variables.

HTML variables.
In the statement foreach($states as $first=>$second), which variable will hold the array key?
$states

$first

$second

$first['state']
How do you reference a function defined in an external file in a PHP program?
Reference the function URL in your PHP code.

Use the $_GET[] array variable.

Use the include() function to include the function code in your PHP program.

Use the $_REQUEST[] array variable.
Which PHP GD2 library function allows us to easily resize existing images?
imagecopyresampled()

imagejpeg()

imagecreatetruecolor()

imagecreatefromstring()
What data type allows you to specify an exact number of decimal places for a number in the data field?
BOOL.

BLOB.

Floating point.

Decimal.
What advanced feature in MySQL allows you to restrict the values placed in a data field?
Constraint.

View.

Trigger.

Stored procedure.
How is a view created?
From defining individual data fields.

From the result of an INSERT statement.

From the result of a SELECT query.

From the result of a DROP TABLE statement.
What is the common term for a Web page that's separate from the normal application home page and provides administrative functions for the application?
A front end.

A home page.

A back end.

A style sheet.
What PHP function allows you to send HTTP headers to the client browser?
header().

session_start().

The $_SESSION[] array variable.

file_get_contents().
What is the area on a Web page that provides quick information about the status of the application called?
The navigation bar.

The dashboard.

The HTTP headers.

The footer.
What function should you use to prepare data before inserting it into a MySQL table?
htmlspecialchars()

nl2br()

mysql_real_escape_string()

ob_start()
What HTML input type should you use to allow a Web page visitor to upload a file from their PC?
The file input type.

The select type.

The option tag.

The MAX_FILE_SIZE value.
What PHP feature should you use to retrieve the name of the uploaded file from an HTML form?
file_get_contents()

$_FILES[]

ob_get_contents()

$_GET[]
What HTML tag should you use to display an image stored in a MySQL database?
<input>

<img>

<table>

header()
What HTML input type allows you to easily display an on/off value for indicating the value of data that's in a Boolean data type?
text.

textarea.

checkbox.

radio button.
What SQL statement should you use to remove a record from the database?
DELETE.

UPDATE.

SELECT.

INSERT.
What function is commonly associated with the storefront application?
Creating new products.

Provide a way for customers to select products for purchase.

Create new product categories.

Process pending customer orders.
Which printf() function special code displays a floating point value with a fixed number of decimal places?
%d

%s

%b

%f
What PHP feature allows you to assign multiple keys to a single session cookie key?
Multidimensional arrays.

Associative arrays.

Numeric arrays.

The foreach() function.
What array format would you use to track product as the array key and the quantity as the value?
$_SESSION['cart'][$quantity] = $prodid

$_SESSION['cart'][$prodid] = $quantity

$_SESSION[$prodid][$quantity]

$_SESSION[$prodid]['cart'] = $quantity
What PHP configuration parameter do you use to set a session cookie to expire before the client's Web browser closes?
session.cookie_lifetime

session.use_only_cookies

session.use_cookies

session.name
What's the best technique to use to prevent having inventory problems while online customers shop?
Update the product database as each customer places an item in the shopping cart.

Minimize the amount of time between when the customer places an item in the shopping cart and when they check out.

Lock the database records for the product until the customer checks out.

Allow only one customer at a time to shop on the Web store.
Which MySQL function should you use to encrypt data stored in a table?
LAST_INSERT_ID()

mysql_real_escape_string()

PASSWORD()

stripslashes()
What does the Web server send to a client browser to encrypt data?
Its public encryption key.

Its private encryption key.

An HTML variable.

A session cookie.
Which MySQL function should you use to retrieve the last auto_increment value assigned during the database connection?
COUNT()

mysql_real_escape_string()

PASSWORD()

LAST_INSERT_ID()
Which MySQL InnoDB database engine feature allows you to process multiple SQL statements as a single unit?
autocommit.

Table constraints.

Transactions.

auto_increment.
What SQL statement allows you to change the attributes or constraints of an existing data field in a table?
ALTER

UPDATE

INSERT

CREATE
What is the way to suppress any error messages from a PHP function and continue processing the program?
Use the 'or die()' feature after the function.

Use the mysql_error() function after the function.

Use the exclamation symbol (!) in front of the function.

Use the 'at' symbol (@) in front of the function.
Which regular expression symbol do you use to match a pattern at the start of a string?
The dollar sign.

The caret character.

The pipe symbol.

The asterisk.
What SQL clause returns records that match the linking data field between two tables?
WHERE t1.custid = t2.custid

WHERE t1.custid > t2.custid

ORDER BY custid

GROUP BY prodid
What HTTP header type do you use to set the application used to open data on the client's browser?
Content-disposition.

Expires.

Location.

Content-type.
What OOP feature holds data values used for the class object?
Methods.

Scope resolution operator.

Properties.

Constructor.
Which visibility keyword causes a class property to be only accessible inside the class definition code?
Private.

Protected.

Public.

$this.
What is the process of creating a new class by extending an existing class called?
Scope resolution.

Visibility.

Instantiate.

Inheritance.

nph-0